How to: Add fields on the Data Pane in MS Query.
Solution:
From within Microsoft Query, double-click the field name in the field list in the table pane, or drag the field name from the field list in the table pane over the blank column into the data pane.
NOTE: Fields must be on the data pane in order to display any data in the data pane. When the completed query is executed, data from fields in the database display in the corresponding field columns in the data pane. Fields can be added one at a time, all at once, or several at once.
1) Choose one of the following means of adding fields on the Data Pane:
a) To add fields one at a time double-click the Field Name in the Field List in the Table Pane, or drag the Field Name from the Field List in the Table Pane over the blank column in the Data Pane.
b) To add the fields all at once double-click the asterisk at the beginning of the Field List on the Table Pane, or drag the asterisk over the blank column in the Data Pane.
c) To add several, but not all fields at once:
1] Select the fields by pressing and holding down the CONTROL key while selecting each field name to be added to the Data Pane.
2] After selecting the field names, drag them over the blank column on the Data Pane.
